package com.ruoyi.system.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface AnswerQuestionMapper {

    @Select("select a.answer_id from answer_question a where a.type = 'question' " +
            "and (#{idcard}!='' and a.shenfenzhenghao = #{idcard}) and (#{year} != '' and SUBSTRING(a.create_time,1,4) = #{year})")
    List<Map<String, Object>> selectByIdcardYear(@Param("year") String  year, @Param("idcard") String  idcard);
}
